package kn.cstf2.implementation.Server;

import kn.cstf2.cop.Bean.CopBean;
import kn.cstf2.transition.Server.*;
import kn.cstf2.login.Server.*;
import kn.cstf2.global.Utils.*;
import kn.cstf2.login.Server.*;
import kn.cstf2.global.Utils.CstF2Exception;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Collection;
import java.util.Date;
import kn.cstf2.implementation.Bean.*;
import kn.cstf2.transition.Bean.TransitionBean;
//import kn.cstf2.transition.Bean.*;
import org.apache.log4j.Logger;

/**
 * @author Izhar Gamaliel Hernandez Cruz Programador Java Junior Desarrollado para
 * Kuehne + Nagel
 */
public class AdaptadorImple {

    private static Logger log = Logger.getLogger(AdaptadorImple.class);

   

        public static ClienteStkBean obtenerTodosDatosFromClientesSTK(ResultSet rs) {
        ClienteStkBean clienteStkBean = null;
        try {
            if (rs.next()) {
                clienteStkBean = new ClienteStkBean();
                clienteStkBean.setKnkey(rs.getInt("knkey"));
                clienteStkBean.setCompanyname(rs.getString("companyname"));
                clienteStkBean.setComercialname(rs.getString("comercialname"));
                clienteStkBean.setCompaddress(rs.getString("compaddress"));
                clienteStkBean.setRfc(rs.getString("rfc"));
                clienteStkBean.setCiudad(rs.getString("ciudad"));
                clienteStkBean.setMcontactname(rs.getString("mcontactname"));
                clienteStkBean.setMcontactposition(rs.getString("mcontactposition"));
                clienteStkBean.setMcontactphone(rs.getString("mcontactphone"));
                clienteStkBean.setMcontactemail(rs.getString("mcontactemail"));
                clienteStkBean.setC2contactname(rs.getString("c2contactname"));
                clienteStkBean.setC2contactposition(rs.getString("c2contactposition"));
                clienteStkBean.setC2contactphone(rs.getString("c2contactphone"));
                clienteStkBean.setC2contactemail(rs.getString("c2contactemail"));
                clienteStkBean.setIndustry(rs.getString("industry"));
                clienteStkBean.setSubindustry(rs.getString("subindustry"));
                clienteStkBean.setActivebillingcust(rs.getString("activebillingcust"));
                clienteStkBean.setAcctype(rs.getString("acctype"));
                clienteStkBean.setAccsponsor(rs.getString("accsponsor"));
                clienteStkBean.setAccountowner(rs.getString("accountowner"));
                clienteStkBean.setAccountexecutive(rs.getString("accountexecutive"));
                clienteStkBean.setInvtterm(rs.getString("invtterm"));
                clienteStkBean.setTop100bygp(rs.getString("top100bygp"));
                clienteStkBean.setTotalclass(rs.getString("totalclass"));
                clienteStkBean.setLastupdatedate(rs.getString("lastupdatedate"));
                clienteStkBean.setCreationdate(rs.getString("creationdate"));
                clienteStkBean.setClientid(rs.getString("clientid"));
                clienteStkBean.setAcon(rs.getString("acon"));
                clienteStkBean.setLogicaladdress(rs.getString("logicaladdress"));
                clienteStkBean.setVisibilitylevel(rs.getString("visibilitylevel"));
                clienteStkBean.setRdata(rs.getString("rdata"));
                clienteStkBean.setRbilliing(rs.getString("rbilliing"));
                clienteStkBean.setRvolume(rs.getString("rvolume"));
                clienteStkBean.setRit(rs.getString("rit"));
                clienteStkBean.setRkpis(rs.getString("rkpis"));
                clienteStkBean.setOther(rs.getString("other"));
                clienteStkBean.setOtherreport(rs.getString("otherreport"));
                clienteStkBean.setAdata(rs.getString("adata"));
                clienteStkBean.setAbilling(rs.getBoolean("abilling"));
                clienteStkBean.setAvolume(rs.getString("avolume"));
                clienteStkBean.setAit(rs.getString("ait"));
                clienteStkBean.setAkpis(rs.getString("akpis"));
                clienteStkBean.setCreditterms(rs.getString("creditterms"));
                clienteStkBean.setCreditcomments(rs.getString("creditcomments"));
                clienteStkBean.setKam(rs.getString("kam"));
                clienteStkBean.setOkam(rs.getString("okam"));
                clienteStkBean.setGkam(rs.getString("gkam"));
                clienteStkBean.setRkam(rs.getString("rkam"));
                clienteStkBean.setCompetitors(rs.getString("competitors"));
                clienteStkBean.setExistanpersonalrelat(rs.getString("existanpersonalrelat"));
                clienteStkBean.setFinancialstability(rs.getString("financialstability"));
                clienteStkBean.setContract(rs.getString("contract"));
                clienteStkBean.setRfqdate(rs.getString("rfqdate"));
                clienteStkBean.setDcs(rs.getString("dcs"));
                clienteStkBean.setUbicadcs(rs.getString("ubicadcs"));
                clienteStkBean.setDesiciondcs(rs.getString("desiciondcs"));
                clienteStkBean.setPlants(rs.getString("plants"));
                clienteStkBean.setUbicaplants(rs.getString("ubicaplants"));
                clienteStkBean.setDesicionplants(rs.getString("desicionplants"));
                clienteStkBean.setLiabilities(rs.getString("liabilities"));
                clienteStkBean.setContract_open(rs.getString("contract_open"));
                clienteStkBean.setContract_close(rs.getString("contract_close"));
                clienteStkBean.setExitclause(rs.getString("exitclause"));
                clienteStkBean.setContract_renewal(rs.getString("contract_renewal"));
                clienteStkBean.setContract_terms(rs.getString("contract_terms"));
                clienteStkBean.setContract_pricing_negociation(rs.getString("contract_pricing_negociation"));
                clienteStkBean.setContract_other(rs.getString("contract_other"));
                clienteStkBean.setContract_commodity(rs.getString("contract_commodity"));
                clienteStkBean.setCurrent_visibility(rs.getString("current_visibility"));
                clienteStkBean.setVisibility_requ(rs.getString("visibility_requ"));
                clienteStkBean.setEdi(rs.getString("edi"));
                clienteStkBean.setErp(rs.getString("erp"));
                clienteStkBean.setEdiformat(rs.getString("ediformat"));
                clienteStkBean.setIvpproduct(rs.getString("ivpproduct"));
                clienteStkBean.setReport_needs(rs.getString("report needs"));
                clienteStkBean.setComments_cust_solution(rs.getString("comments_cust_solution"));
                clienteStkBean.setCb_fa(rs.getString("cb_fa"));
                clienteStkBean.setCb_fd(rs.getString("cb_fd"));
                clienteStkBean.setCb_fg(rs.getString("cb_fg"));
                clienteStkBean.setCb_fo(rs.getString("cb_fo"));
                clienteStkBean.setCb_fs(rs.getString("cb_fs"));
                clienteStkBean.setCb_fw(rs.getString("cb_fw"));
                clienteStkBean.setCb_fx(rs.getString("cb_fx"));
                clienteStkBean.setCb_fy(rs.getString("cb_fy"));
                clienteStkBean.setCb_fz(rs.getString("cb_fz"));
                clienteStkBean.setPb_fa(rs.getString("pb_fa"));
                clienteStkBean.setPb_fd(rs.getString("pb_fd"));
                clienteStkBean.setPb_fg(rs.getString("pb_fg"));
                clienteStkBean.setPb_fo(rs.getString("pb_fo"));
                clienteStkBean.setPb_fs(rs.getString("pb_fs"));
                clienteStkBean.setPb_fw(rs.getString("pb_fw"));
                clienteStkBean.setPb_fx(rs.getString("pb_fx"));
                clienteStkBean.setPb_fy(rs.getString("pb_fy"));
                clienteStkBean.setPb_fz(rs.getString("pb_fz"));
                clienteStkBean.setVlog_check_acon(rs.getString("vlog_check_acon"));
                clienteStkBean.setVlog_check_logadd(rs.getString("vlog_check_logadd"));
                clienteStkBean.setVlog_check_organization(rs.getString("vlog_check_organization"));
                clienteStkBean.setVlog_check_contact(rs.getString("vlog_check_contact"));
                clienteStkBean.setVlog_check_opportu(rs.getString("vlog_check_opportu"));
                clienteStkBean.setVlog_check_quotation(rs.getString("vlog_check_quotation"));
                clienteStkBean.setVlog_check_signed(rs.getString("vlog_check_signed"));
                clienteStkBean.setVlog_check_sop(rs.getString("vlog_check_sop"));
                clienteStkBean.setAlert_delivered(rs.getString("alert_delivered"));
                clienteStkBean.setAlert_other(rs.getString("alert_other"));
                clienteStkBean.setInvoice_receive_date(rs.getString("invoice_receive_date"));
                clienteStkBean.setCreditlimit(rs.getString("creditlimit"));
                clienteStkBean.setBillingcurrency(rs.getString("billingcurrency"));
                clienteStkBean.setBillingto(rs.getString("billingto"));
                clienteStkBean.setInvoicerevisiondate(rs.getString("invoicerevisiondate"));
                clienteStkBean.setPayablecontactname(rs.getString("payablecontactname"));
                clienteStkBean.setPayablecontactphone(rs.getString("payablecontactphone"));
                clienteStkBean.setPayablecontactemail(rs.getString("payablecontactemail"));
                clienteStkBean.setSpecialinvoicecomments(rs.getString("specialinvoicecomments"));
                clienteStkBean.setAccountprofilecoments(rs.getString("accountprofilecoments"));
                clienteStkBean.setObjectivesaccprofile(rs.getString("objectivesaccprofile"));
                clienteStkBean.setBeginingdate_accprofile(rs.getString("beginingdate_accprofile"));
                clienteStkBean.setDeadlinedate_accprofile(rs.getString("deadlinedate_accprofile"));
                clienteStkBean.setQbryear(rs.getString("qbryear"));
                clienteStkBean.setQbr(rs.getString("qbr"));
                clienteStkBean.setKnparticipants(rs.getString("knparticipants"));
                clienteStkBean.setCustparticipants(rs.getString("custparticipants"));
                clienteStkBean.setSc_otros(rs.getString("sc_otros"));
                clienteStkBean.setSc_proyects(rs.getString("sc_proyects"));
                clienteStkBean.setSc_almacenaje(rs.getString("sc_almacenaje"));
                clienteStkBean.setSc_distrib(rs.getString("sc_distrib"));
                clienteStkBean.setSc_fact_mens_fw(rs.getString("sc_fact_mens_fw"));
                clienteStkBean.setSc_gp_mensual_fw(rs.getString("sc_gp_mensual_fw"));
                clienteStkBean.setSc_fact_mens_fd(rs.getString("sc_fact_mens_fd"));
                clienteStkBean.setSc_gp_mensual_fd(rs.getString("sc_gp_mensual_fd"));
                clienteStkBean.setShipping_comments(rs.getString("shipping_comments"));
                clienteStkBean.setChklistbeginingdate_ff(rs.getString("chklistbeginingdate_ff"));
                clienteStkBean.setChklistfinishingdate_ff(rs.getString("chklistfinishingdate_ff"));
                clienteStkBean.setChklistbeginningdate_cl(rs.getString("chklistbeginningdate_cl"));
                clienteStkBean.setChklistfinishingdate_cl(rs.getString("chklistfinishingdate_cl"));
                clienteStkBean.setCl_comomdity(rs.getString("cl_comomdity"));
                clienteStkBean.setCl_wms(rs.getString("cl_wms"));
                clienteStkBean.setCl_tms(rs.getString("cl_tms"));
                clienteStkBean.setCl_wms_detail(rs.getString("cl_wms_detail"));
                clienteStkBean.setCl_tms_detail(rs.getString("cl_tms_detail"));
                clienteStkBean.setAcc_plann_date(rs.getString("acc_plann_date"));
                clienteStkBean.setLastupdate_date(rs.getString("lastupdate_date"));
                clienteStkBean.setCust_zipcode(rs.getString("cust_zipcode"));
                clienteStkBean.setCust_comments(rs.getString("cust_comments"));
                clienteStkBean.setTmkt_saleslead(rs.getString("tmkt_saleslead"));
                clienteStkBean.setChklist_cq(rs.getString("chklist_cq"));
                clienteStkBean.setChklist_cp(rs.getString("chklist_cp"));
                clienteStkBean.setChklist_ap(rs.getString("chklist_ap"));
                clienteStkBean.setChklist_chek(rs.getString("chklist_chek"));
                clienteStkBean.setChklist_internal(rs.getString("chklist_internal"));
                clienteStkBean.setChklist_csummary(rs.getString("chklist_csummary"));
                clienteStkBean.setCreator(rs.getString("creator"));
                clienteStkBean.setCreator_date(rs.getString("creator_date"));
                clienteStkBean.setNext_rfq_ff(rs.getString("next_rfq_ff"));
                clienteStkBean.setNext_rfq_cl(rs.getString("next_rfq_cl"));
                clienteStkBean.setAccount_family(rs.getString("account_family"));

          
                
            }
        } catch (SQLException ex) {
            log.error("No se pudo obtener la informacion del Usuario", ex);
            throw new CstF2Exception("No se pudo obtener la informacion del Usuario");
        }
        return clienteStkBean;
    }

      
   

        public static ClienteStkBean obtenerAcountVisibilitySTK(ResultSet rs) {
        ClienteStkBean clienteStkBean = new ClienteStkBean();
        ArrayList<String> arr = new ArrayList<String>();
        try {
            while (rs.next()) {   
                arr.add(rs.getString("winuser"));
            }
                clienteStkBean.setAccounts_visibility(arr);
            
            
        } catch (SQLException ex) {
            log.error("No se pudo obtener la informacion del Usuario", ex);
            throw new CstF2Exception("No se pudo obtener la informacion del Usuario");
        }
        return clienteStkBean;
    }

      
              

        public static T_asignStkBean obtenerIfOwnerFromSTK(ResultSet rs) {
        T_asignStkBean t_asignStkBean = null;
        try {
            if (rs.next()) {
                t_asignStkBean = new T_asignStkBean();
                t_asignStkBean.setIfowner(rs.getString("ifowner"));
                
            }
        } catch (SQLException ex) {
            log.error("No se pudo obtener la informacion del Usuario", ex);
            throw new CstF2Exception("No se pudo obtener la informacion del Usuario");
        }
        return t_asignStkBean;
    }
      
        
        public static JoindocumenttransitionBean obtenerStatusFechaArchivo(ResultSet rs) {
        JoindocumenttransitionBean joindocumenttransitionBean = null;
        try {
            if (rs.next()) {
                joindocumenttransitionBean = new JoindocumenttransitionBean();
                joindocumenttransitionBean.setVobo(rs.getBoolean("vobo"));
                joindocumenttransitionBean.setUploaded(rs.getBoolean("uploaded"));
                joindocumenttransitionBean.setCompletiondate(rs.getString("completiondate"));
                
            }
        } catch (SQLException ex) {
            log.error("No se pudo obtener la informacion del Usuario", ex);
            throw new CstF2Exception("No se pudo obtener la informacion del Usuario");
        }
        return joindocumenttransitionBean;
    }
        
        
        public static TransitionBean obtenerTransitionBean(ResultSet rs) {
        TransitionBean  transitionBean = new TransitionBean();
        try {
            while (rs.next()) {
                //TransitionBean  transitionBean1 = new TransitionBean();
                //joinusertransition = new Joinusertransition();
                transitionBean.setId(rs.getInt("id"));
                //transitionBean1.setKnkey(rs.getInt("knkey"));
                //transitionBean.add(transitionBean1);
            }
        } catch (SQLException ex) {
            log.error("No se pudo obtener la informacion del Usuario", ex);
            throw new CstF2Exception("No se pudo obtener la informacion del Usuario");
        }
        return transitionBean;
    }
        
     
       public static DocumentsBean obtenerIdFromDocuments(ResultSet rs) {
        DocumentsBean  documentsBean = new DocumentsBean();
        try {
            while (rs.next()) {

                documentsBean.setId(rs.getInt("id"));

            }
        } catch (SQLException ex) {
            log.error("No se pudo obtener la informacion del Usuario", ex);
            throw new CstF2Exception("No se pudo obtener la informacion del Usuario");
        }
        return documentsBean;
    }     
        
        
       
     public static TransitionsBeanImp obtenerllRestInforT_transition(ResultSet rs) {
        TransitionsBeanImp  transitionsBeanImp = new TransitionsBeanImp();
        try {
            while (rs.next()) {

                transitionsBeanImp.setId(rs.getInt("id"));
                transitionsBeanImp.setKnkey(rs.getInt("knkey"));
                transitionsBeanImp.setStatus(rs.getString("status"));
                transitionsBeanImp.setLog(rs.getString("log"));
                transitionsBeanImp.setContacts(rs.getBoolean("contacts"));
                transitionsBeanImp.setContactsdate(rs.getString("contactsdate"));
                transitionsBeanImp.setReporting(rs.getBoolean("reporting"));
                transitionsBeanImp.setReportingdate(rs.getString("reportingdate"));
                transitionsBeanImp.setScopeofservice(rs.getBoolean("scopeofservice"));
                transitionsBeanImp.setScopeofservicedate(rs.getString("scopeofservicedate"));
                transitionsBeanImp.setCondition(rs.getBoolean("condition"));
                transitionsBeanImp.setConditionsdate(rs.getString("conditionsdate"));
                transitionsBeanImp.setCielid(rs.getBoolean("cielid"));
                transitionsBeanImp.setCieliddate(rs.getString("cieliddate"));
                transitionsBeanImp.setCielqmodule(rs.getBoolean("cielqmodule"));
                transitionsBeanImp.setCielqmoduledate(rs.getString("cielqmoduledate"));
                transitionsBeanImp.setAcon(rs.getBoolean("acon"));
                transitionsBeanImp.setAcondate(rs.getString("acondate"));
                transitionsBeanImp.setCarriercc(rs.getBoolean("carriercc"));
                transitionsBeanImp.setCarrierccdate(rs.getString("carrierccdate"));
                transitionsBeanImp.setWorkingst(rs.getBoolean("workingst"));
                transitionsBeanImp.setWorkingstdate(rs.getString("workingstdate"));
                transitionsBeanImp.setSop(rs.getBoolean("sop"));
                transitionsBeanImp.setSopdate(rs.getString("sopdate"));
                transitionsBeanImp.setKpi(rs.getBoolean("kpi"));
                transitionsBeanImp.setKpidate(rs.getString("kpidate"));
                transitionsBeanImp.setBilling(rs.getBoolean("billing"));
                transitionsBeanImp.setBillingdate(rs.getString("billingdate"));
                transitionsBeanImp.setCop(rs.getBoolean("cop"));
                transitionsBeanImp.setCopdate(rs.getString("copdate"));
                
            }
        } catch (SQLException ex) {
            log.error("No se pudo obtener la informacion del Usuario", ex);
            throw new CstF2Exception("No se pudo obtener la informacion del Usuario");
        }
        return transitionsBeanImp;
    }        
       
     public static TransitionsBeanImp actualizarStatusDocumentsCop(ResultSet rs) {
        TransitionsBeanImp transitionsBeanImp = new TransitionsBeanImp();
        try {
            while (rs.next()) {
               String df = rs.getString("copdate");
                transitionsBeanImp.setCopdate(df);

            }
        } catch (SQLException ex) {
            log.error("No se pudo obtener la informacion del Usuario", ex);
            throw new CstF2Exception("No se pudo obtener la informacion del Usuario");
        }
        return transitionsBeanImp;
    }     
     
     public static TransitionsBeanImp actualizarStatusDocumentsContacts(ResultSet rs) {
        TransitionsBeanImp transitionsBeanImp = new TransitionsBeanImp();
        try {
            while (rs.next()) {
               String df = rs.getString("contactsdate");
                transitionsBeanImp.setContactsdate(df);

            }
        } catch (SQLException ex) {
            log.error("No se pudo obtener la informacion del Usuario", ex);
            throw new CstF2Exception("No se pudo obtener la informacion del Usuario");
        }
        return transitionsBeanImp;
    }     
     
     public static TransitionsBeanImp actualizarStatusDocumentsReporting(ResultSet rs) {
        TransitionsBeanImp transitionsBeanImp = new TransitionsBeanImp();
        try {
            while (rs.next()) {
               String df = rs.getString("reportingdate");
                transitionsBeanImp.setReportingdate(df);

            }
        } catch (SQLException ex) {
            log.error("No se pudo obtener la informacion del Usuario", ex);
            throw new CstF2Exception("No se pudo obtener la informacion del Usuario");
        }
        return transitionsBeanImp;
    }
     
     public static TransitionsBeanImp actualizarStatusDocumentsSos(ResultSet rs) {
        TransitionsBeanImp transitionsBeanImp = new TransitionsBeanImp();
        try {
            while (rs.next()) {
               String df = rs.getString("scopeofservicedate");
                transitionsBeanImp.setScopeofservicedate(df);

            }
        } catch (SQLException ex) {
            log.error("No se pudo obtener la informacion del Usuario", ex);
            throw new CstF2Exception("No se pudo obtener la informacion del Usuario");
        }
        return transitionsBeanImp;
    }
     
     public static TransitionsBeanImp actualizarStatusDocumentsConditions(ResultSet rs) {
        TransitionsBeanImp transitionsBeanImp = new TransitionsBeanImp();
        try {
            while (rs.next()) {
               String df = rs.getString("conditionsdate");
                transitionsBeanImp.setConditionsdate(df);

            }
        } catch (SQLException ex) {
            log.error("No se pudo obtener la informacion del Usuario", ex);
            throw new CstF2Exception("No se pudo obtener la informacion del Usuario");
        }
        return transitionsBeanImp;
    }
       
        
     public static TransitionsBeanImp actualizarStatusDocumentsCielID(ResultSet rs) {
        TransitionsBeanImp transitionsBeanImp = new TransitionsBeanImp();
        try {
            while (rs.next()) {
               String df = rs.getString("cieliddate");
                transitionsBeanImp.setCieliddate(df);

            }
        } catch (SQLException ex) {
            log.error("No se pudo obtener la informacion del Usuario", ex);
            throw new CstF2Exception("No se pudo obtener la informacion del Usuario");
        }
        return transitionsBeanImp;
    }     
       
        
      public static TransitionsBeanImp actualizarStatusDocumentsCielQ(ResultSet rs) {
        TransitionsBeanImp transitionsBeanImp = new TransitionsBeanImp();
        try {
            while (rs.next()) {

                transitionsBeanImp.setCielqmoduledate(rs.getString("cielqmoduledate"));

            }
        } catch (SQLException ex) {
            log.error("No se pudo obtener la informacion del Usuario", ex);
            throw new CstF2Exception("No se pudo obtener la informacion del Usuario");
        }
        return transitionsBeanImp;
    }     
      
      
       public static TransitionsBeanImp actualizarStatusDocumentsCarrier(ResultSet rs) {
        TransitionsBeanImp transitionsBeanImp = new TransitionsBeanImp();
        try {
            while (rs.next()) {

                transitionsBeanImp.setCarrierccdate(rs.getString("carrierccdate"));

            }
        } catch (SQLException ex) {
            log.error("No se pudo obtener la informacion del Usuario", ex);
            throw new CstF2Exception("No se pudo obtener la informacion del Usuario");
        }
        return transitionsBeanImp;
    }  
       
       
       public static TransitionsBeanImp actualizarStatusDocumentsWorking(ResultSet rs) {
        TransitionsBeanImp transitionsBeanImp = new TransitionsBeanImp();
        try {
            while (rs.next()) {
               String df = rs.getString("workingstdate");
                transitionsBeanImp.setWorkingstdate(df);

            }
        } catch (SQLException ex) {
            log.error("No se pudo obtener la informacion del Usuario", ex);
            throw new CstF2Exception("No se pudo obtener la informacion del Usuario");
        }
        return transitionsBeanImp;
    }
       
       public static TransitionsBeanImp actualizarStatusDocumentsSop(ResultSet rs) {
        TransitionsBeanImp transitionsBeanImp = new TransitionsBeanImp();
        try {
            while (rs.next()) {
               String df = rs.getString("sopdate");
                transitionsBeanImp.setSopdate(df);

            }
        } catch (SQLException ex) {
            log.error("No se pudo obtener la informacion del Usuario", ex);
            throw new CstF2Exception("No se pudo obtener la informacion del Usuario");
        }
        return transitionsBeanImp;
    }
       
       public static TransitionsBeanImp actualizarStatusDocumentsKpi(ResultSet rs) {
        TransitionsBeanImp transitionsBeanImp = new TransitionsBeanImp();
        try {
            while (rs.next()) {
               String df = rs.getString("kpidate");
                transitionsBeanImp.setKpidate(df);

            }
        } catch (SQLException ex) {
            log.error("No se pudo obtener la informacion del Usuario", ex);
            throw new CstF2Exception("No se pudo obtener la informacion del Usuario");
        }
        return transitionsBeanImp;
    }
       
       public static TransitionsBeanImp actualizarStatusDocumentsBilling(ResultSet rs) {
        TransitionsBeanImp transitionsBeanImp = new TransitionsBeanImp();
        try {
            while (rs.next()) {
               String df = rs.getString("billingdate");
                transitionsBeanImp.setBillingdate(df);

            }
        } catch (SQLException ex) {
            log.error("No se pudo obtener la informacion del Usuario", ex);
            throw new CstF2Exception("No se pudo obtener la informacion del Usuario");
        }
        return transitionsBeanImp;
    }
       
       
      public static DateStatusTransitionsBean obtenerFechaStatusTransitions(ResultSet rs) {
          
        DateStatusTransitionsBean dateStatusTransitionsBean = new DateStatusTransitionsBean();
        try {
            while (rs.next()) {

                dateStatusTransitionsBean.setContactsdate(rs.getString("contactsdate"));
                dateStatusTransitionsBean.setReportingdate(rs.getString("reportingdate"));
                dateStatusTransitionsBean.setScopeofservicedate(rs.getString("scopeofservicedate"));
                dateStatusTransitionsBean.setConditionsdate(rs.getString("conditionsdate"));
                dateStatusTransitionsBean.setCieliddate(rs.getString("cieliddate"));
                dateStatusTransitionsBean.setCielqmoduledate(rs.getString("cielqmoduledate"));
                dateStatusTransitionsBean.setAcondate(rs.getString("acondate"));
                dateStatusTransitionsBean.setCarrierccdate(rs.getString("carrierccdate"));
                dateStatusTransitionsBean.setWorkingstdate(rs.getString("workingstdate"));
                dateStatusTransitionsBean.setSopdate(rs.getString("sopdate"));
                dateStatusTransitionsBean.setKpidate(rs.getString("kpidate"));
                dateStatusTransitionsBean.setBillingdate(rs.getString("billingdate"));
                dateStatusTransitionsBean.setCopdate(rs.getString("copdate"));
   

            }
        } catch (SQLException ex) {
            log.error("No se pudo obtener la informacion del Usuario", ex);
            throw new CstF2Exception("No se pudo obtener la informacion del Usuario");
        }
        return dateStatusTransitionsBean;
    }    
      
      
      public static DateStatusTransitionsBean obtenerDatesStatusTransitions(ResultSet rs) {
          
        DateStatusTransitionsBean dateStatusTransitionsBean = new DateStatusTransitionsBean();
        try {
            while (rs.next()) {

                dateStatusTransitionsBean.setContactsdate(rs.getString("contactsfecha"));
                dateStatusTransitionsBean.setReportingdate(rs.getString("reportingfecha"));
                dateStatusTransitionsBean.setScopeofservicedate(rs.getString("sosfecha"));
                dateStatusTransitionsBean.setConditionsdate(rs.getString("conditionsfecha"));
                dateStatusTransitionsBean.setCieliddate(rs.getString("cielidfecha"));
                dateStatusTransitionsBean.setCielqmoduledate(rs.getString("cielqmfecha"));
                dateStatusTransitionsBean.setCarrierccdate(rs.getString("carrierfecha"));
                dateStatusTransitionsBean.setWorkingstdate(rs.getString("workingfecha"));
                dateStatusTransitionsBean.setSopdate(rs.getString("sopfecha"));
                dateStatusTransitionsBean.setKpidate(rs.getString("kpifecha"));
                dateStatusTransitionsBean.setBillingdate(rs.getString("billingfecha"));
                dateStatusTransitionsBean.setCopdate(rs.getString("copfecha"));
   

            }
        } catch (SQLException ex) {
            log.error("No se pudo obtener la informacion del Usuario", ex);
            throw new CstF2Exception("No se pudo obtener la informacion del Usuario");
        }
        return dateStatusTransitionsBean;
    }    
      

        
        public static JoindocumenttransitionBean obtenerJoindocumenttransitionData(ResultSet rs) {
        JoindocumenttransitionBean joindocumenttransitionBean = null; 
        try {
            if (rs.next()) {
                joindocumenttransitionBean = new JoindocumenttransitionBean();
                joindocumenttransitionBean.setVobo(rs.getBoolean("vobo"));    
                joindocumenttransitionBean.setUploaded(rs.getBoolean("uploaded"));    
                joindocumenttransitionBean.setCompletiondate(rs.getString("completiondate"));    
               
            }
        } catch (SQLException ex) {
            log.error("No se pudo obtener la informacion del Usuario", ex);
            throw new CstF2Exception("No se pudo obtener la informacion del Usuario");
        }
        return joindocumenttransitionBean;
    }   
        
        
        

}
   